package com.hlm.analysis;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Mapper
@Repository
public interface Tempreture {

    @Select("SELECT temp_in+0\n" +
            "FROM user27106\n" +
            "ORDER BY date")
    double[] getInTemp();

    @Select("SELECT temp_water+0\n" +
            "FROM user27106\n" +
            "ORDER BY date")
    double[] getWaterTemp();

    @Select("SELECT temp_out +0\n" +
            "FROM user27106\n" +
            "ORDER BY date")
    double[] getOutTemp();

    @Select("SELECT temp_in+0\n" +
            "FROM user26898 u\n" +
            "ORDER BY date")
    double[] get26898Intemp();
    @Select("SELECT temp_water+0\n" +
            "FROM user26898 u\n" +
            "ORDER BY date")
    double[] get26898WaterTemp();
    @Select("SELECT temp_out+0\n" +
            "FROM user26898 u\n" +
            "ORDER BY date")
    double[] get26898OutTemp();

    @Select("SELECT in_temp+0\n" +
            "FROM user26920\n" +
            "GROUP BY date")
    double[] get26920Intemp();
    @Select("SELECT out_temp+0\n" +
            "FROM user26920\n" +
            "GROUP BY date\n")
    double[] get26920OutTemp();
    @Select("SELECT water_temp+0\n" +
            "FROM user26920\n" +
            "GROUP BY date\n")
    double[] get26920WaterTemp();
}
